CREATE TABLE [dbo].[Cert_Register]
(
[SEQN] [int] NOT NULL CONSTRAINT [DF_Cert_Register_SEQN] DEFAULT ((0)),
[STUDENT_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Cert_Register_STUDENT_ID] DEFAULT (''),
[BT_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Cert_Register_BT_ID] DEFAULT (''),
[REGISTRATION_ITEM] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Cert_Register_REGISTRATION_ITEM] DEFAULT (''),
[REG_TYPE] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Cert_Register_REG_TYPE] DEFAULT (''),
[DESCRIPTION] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Cert_Register_DESCRIPTION] DEFAULT (''),
[STATUS] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Cert_Register_STATUS] DEFAULT (''),
[UNITS_EARNED] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Cert_Register_UNITS_EARNED] DEFAULT ((0)),
[GRADE_TEXT] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Cert_Register_GRADE_TEXT] DEFAULT (''),
[ENROLLED_DATE] [datetime] NULL,
[COMPLETION_DATE] [datetime] NULL,
[CANCELED_DATE] [datetime] NULL,
[GOOD_THRU_DATE] [datetime] NULL,
[DEADLINE] [datetime] NULL,
[TOTAL_CHARGES] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Cert_Register_TOTAL_CHARGES] DEFAULT ((0)),
[ORDER_NUMBER] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Cert_Register_ORDER_NUMBER] DEFAULT ((0)),
[ACTIVITY_SEQN] [int] NOT NULL CONSTRAINT [DF_Cert_Register_ACTIVITY_SEQN] DEFAULT ((0)),
[PROGRAM_ID] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Cert_Register_PROGRAM_ID] DEFAULT (''),
[BOARD_NOTIFIED] [bit] NOT NULL CONSTRAINT [DF_Cert_Register_BOARD_NOTIFIED] DEFAULT ((0)),
[STUDENT_NOTIFIED] [bit] NOT NULL CONSTRAINT [DF_Cert_Register_STUDENT_NOTIFIED] DEFAULT ((0)),
[BOARD_NOTIFIED_DATE] [datetime] NULL,
[STUDENT_NOTIFIED_DATE] [datetime] NULL,
[NOTES] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UF_1] [bit] NOT NULL CONSTRAINT [DF_Cert_Register_UF_1] DEFAULT ((0)),
[UF_2] [bit] NOT NULL CONSTRAINT [DF_Cert_Register_UF_2] DEFAULT ((0)),
[UF_3] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Cert_Register_UF_3] DEFAULT (''),
[UF_4] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Cert_Register_UF_4] DEFAULT (''),
[REQUIREMENT_TYPE] [tinyint] NOT NULL CONSTRAINT [DF_Cert_Register_REQUIREMENT_TYPE] DEFAULT ((0)),
[PROGRAM_REG_SEQN] [int] NOT NULL CONSTRAINT [DF_Cert_Register_PROGRAM_REG_SEQN] DEFAULT ((0)),
[IN_GRACE_PERIOD] [bit] NOT NULL CONSTRAINT [DF_Cert_Register_IN_GRACE_PERIOD] DEFAULT ((0)),
[COMPONENT_INSTANCE] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Cert_Register_COMPONENT_INSTANCE] DEFAULT (''),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
ALTER TABLE [dbo].[Cert_Register] ADD CONSTRAINT [PK_Cert_Register] PRIMARY KEY NONCLUSTERED ([SEQN]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iCert_RegisterREGISTRATION_ITE] ON [dbo].[Cert_Register] ([REGISTRATION_ITEM]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iCert_RegisterSTUDENT_ID] ON [dbo].[Cert_Register] ([STUDENT_ID]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Cert_Register] TO [IMIS]
GRANT SELECT ON  [dbo].[Cert_Register] TO [IMIS]
GRANT INSERT ON  [dbo].[Cert_Register] TO [IMIS]
GRANT DELETE ON  [dbo].[Cert_Register] TO [IMIS]
GRANT UPDATE ON  [dbo].[Cert_Register] TO [IMIS]
GO